Change a plan file calc method

You may need to change a calc method for an item in one of the blocks on the Forecast worksheet; for example, if an RFCode has been deprecated because it will not be used in the future or has been replaced by another RFCode but you still need the legacy data associated with it to appear in the Actuals columns of the Forecast report. Or, if an RFCode has been assigned the No Forecast or Volume Calc method and you want to change it to something else, you can use these instructions.

NOTE: Prior to version 2022.1, when you saved a plan file, the calc method used was saved to the ForecastFinal line for that RFCode, and that calc method assignment had the highest priority in the plan file. With version 2022.1, the calc method assigned to an RFCode in the RFCODE table has priority.

NOTE: You must have permissions to change calculation methods to use this feature. Users with the Axiom Rolling Forecasting User role can be granted these permissions in the Security Manager.

To change a calc method:

NOTE: While it is possible to edit the RFCODE dimension table, this is not recommended. The safest way to change a calc method is to use the Dimension Maintenance utility to edit the dimension.

  1. In the RF Admin task pane, in the Tables section, double-click Dimension Maintenance.

    NOTE: The No Forecast calc method cannot be used in the IP Census section of the Forecast worksheet.

  2. From the Refresh Variables dialog drop-down, select RF - Rolling Forecast.

  3. From the Select a Dimension to Edit drop-down, select RFCODE.

    TIP: To retrieve a smaller subset of data, you can use the Quick Filter in the Workbook Options of the Main ribbon tab. For detailed instructions on how to use the feature, see Applying a Quick Filter to a report.

  4. In the RFCODE column of the Dimension Maintenance utility, locate the RFCode with the calc method to be changed, and then do one of the following:

    • To change the calc method for a Forecast RFCode, in the ForecastStdLine column for the RFCode row, double-click the folder icon () to the right of the current calc method name. In the Choose Value dialog, select the new calc method, and then click OK.

    • To change the calc method for an Initiative RFCode, in the InitStdLine column for the RFCode row, double-click the folder icon () to the right of the current calc method name. In the Choose Value dialog, select the new calc method, and then click OK.

  5. In the Main ribbon tab, click Save.

  6. To view the changes, rebuild and then open the plans.

See also